/ NetNews Offline 2 / NetNews Offline Volume 2.iso / news / comp / lang / rexx / 269

< prev

next >

MacOS 8.1

Win98

DOS

browse contents

view JSON data

view as text

+--------+-------------------------+-------------------------+--------+--------+
|00000000| 50 61 74 68 3a 20 6e 65 | 77 73 2e 71 75 74 2e 65 |Path: ne|ws.qut.e|
|00000010| 64 75 2e 61 75 21 68 65 | 73 73 6c 69 6e 6d 0a 46 |du.au!he|sslinm.F|
|00000020| 72 6f 6d 3a 20 68 65 73 | 73 6c 69 6e 6d 40 6e 65 |rom: hes|slinm@ne|
|00000030| 77 73 2e 71 75 74 2e 65 | 64 75 2e 61 75 20 28 68 |ws.qut.e|du.au (h|
|00000040| 65 73 73 6c 69 6e 67 20 | 6d 61 72 6b 20 29 0a 4e |essling |mark ).N|
|00000050| 65 77 73 67 72 6f 75 70 | 73 3a 20 63 6f 6d 70 2e |ewsgroup|s: comp.|
|00000060| 6c 61 6e 67 2e 72 65 78 | 78 2c 63 6f 6d 70 2e 64 |lang.rex|x,comp.d|
|00000070| 61 74 61 62 61 73 65 73 | 2e 6f 72 61 63 6c 65 0a |atabases|.oracle.|
|00000080| 53 75 62 6a 65 63 74 3a | 20 52 65 3a 20 52 45 58 |Subject:| Re: REX|
|00000090| 58 20 4c 69 62 72 61 72 | 79 20 6f 66 20 4f 72 61 |X Librar|y of Ora|
|000000a0| 63 6c 65 20 46 75 6e 63 | 74 69 6f 6e 73 3f 0a 46 |cle Func|tions?.F|
|000000b0| 6f 6c 6c 6f 77 75 70 2d | 54 6f 3a 20 63 6f 6d 70 |ollowup-|To: comp|
|000000c0| 2e 6c 61 6e 67 2e 72 65 | 78 78 2c 63 6f 6d 70 2e |.lang.re|xx,comp.|
|000000d0| 64 61 74 61 62 61 73 65 | 73 2e 6f 72 61 63 6c 65 |database|s.oracle|
|000000e0| 0a 44 61 74 65 3a 20 31 | 35 20 4a 61 6e 20 31 39 |.Date: 1|5 Jan 19|
|000000f0| 39 36 20 31 31 3a 32 37 | 3a 30 36 20 47 4d 54 0a |96 11:27|:06 GMT.|
|00000100| 4f 72 67 61 6e 69 7a 61 | 74 69 6f 6e 3a 20 51 75 |Organiza|tion: Qu|
|00000110| 65 65 6e 73 6c 61 6e 64 | 20 55 6e 69 76 65 72 73 |eensland| Univers|
|00000120| 69 74 79 20 6f 66 20 54 | 65 63 68 6e 6f 6c 6f 67 |ity of T|echnolog|
|00000130| 79 2c 20 41 75 73 74 72 | 61 6c 69 61 0a 44 69 73 |y, Austr|alia.Dis|
|00000140| 74 72 69 62 75 74 69 6f | 6e 3a 20 69 6e 65 74 0a |tributio|n: inet.|
|00000150| 4d 65 73 73 61 67 65 2d | 49 44 3a 20 3c 34 64 64 |Message-|ID: <4dd|
|00000160| 64 6d 61 24 61 71 65 40 | 73 74 6f 72 6b 2e 71 75 |dma$aqe@|stork.qu|
|00000170| 74 2e 65 64 75 2e 61 75 | 3e 0a 52 65 66 65 72 65 |t.edu.au|>.Refere|
|00000180| 6e 63 65 73 3a 20 3c 34 | 64 30 69 68 38 24 36 6f |nces: <4|d0ih8$6o|
|00000190| 34 40 65 78 70 6c 6f 72 | 65 72 2e 63 73 63 2e 63 |4@explor|er.csc.c|
|000001a0| 6f 6d 3e 20 3c 34 64 63 | 6a 61 6a 24 35 6a 71 40 |om> <4dc|jaj$5jq@|
|000001b0| 77 61 67 65 2e 63 79 62 | 65 72 73 70 61 63 65 2e |wage.cyb|erspace.|
|000001c0| 63 6f 6d 3e 0a 4e 4e 54 | 50 2d 50 6f 73 74 69 6e |com>.NNT|P-Postin|
|000001d0| 67 2d 48 6f 73 74 3a 20 | 70 69 67 65 6f 6e 2e 71 |g-Host: |pigeon.q|
|000001e0| 75 74 2e 65 64 75 2e 61 | 75 0a 4d 69 6d 65 2d 56 |ut.edu.a|u.Mime-V|
|000001f0| 65 72 73 69 6f 6e 3a 20 | 31 2e 30 0a 43 6f 6e 74 |ersion: |1.0.Cont|
|00000200| 65 6e 74 2d 54 79 70 65 | 3a 20 74 65 78 74 2f 70 |ent-Type|: text/p|
|00000210| 6c 61 69 6e 3b 20 63 68 | 61 72 73 65 74 3d 55 53 |lain; ch|arset=US|
|00000220| 2d 41 53 43 49 49 0a 43 | 6f 6e 74 65 6e 74 2d 54 |-ASCII.C|ontent-T|
|00000230| 72 61 6e 73 66 65 72 2d | 45 6e 63 6f 64 69 6e 67 |ransfer-|Encoding|
|00000240| 3a 20 37 62 69 74 0a 58 | 2d 4e 65 77 73 72 65 61 |: 7bit.X|-Newsrea|
|00000250| 64 65 72 3a 20 54 49 4e | 20 5b 76 65 72 73 69 6f |der: TIN| [versio|
|00000260| 6e 20 31 2e 32 20 50 4c | 32 5d 0a 0a 4a 69 6d 20 |n 1.2 PL|2]..Jim |
|00000270| 43 6c 61 72 6b 20 28 65 | 6e 74 72 6f 70 79 40 63 |Clark (e|ntropy@c|
|00000280| 79 62 65 72 73 70 61 63 | 65 2e 63 6f 6d 29 20 77 |yberspac|e.com) w|
|00000290| 72 6f 74 65 3a 0a 3a 20 | 49 6e 20 3c 34 64 30 69 |rote:.: |In <4d0i|
|000002a0| 68 38 24 36 6f 34 40 65 | 78 70 6c 6f 72 65 72 2e |h8$6o4@e|xplorer.|
|000002b0| 63 73 63 2e 63 6f 6d 3e | 2c 20 73 70 65 6c 65 67 |csc.com>|, speleg|
|000002c0| 61 6e 40 63 73 63 2e 63 | 6f 6d 20 20 5b 53 74 65 |an@csc.c|om  [Ste|
|000002d0| 77 20 50 65 6c 65 67 61 | 6e 5d 20 77 72 69 74 65 |w Pelega|n] write|
|000002e0| 73 3a 0a 3a 20 3e 49 27 | 76 65 20 68 65 61 72 64 |s:.: >I'|ve heard|
|000002f0| 20 61 20 72 75 6d 6f 72 | 20 74 68 61 74 20 74 68 | a rumor| that th|
|00000300| 65 72 65 20 69 73 20 61 | 20 52 45 58 58 20 6c 69 |ere is a| REXX li|
|00000310| 62 72 61 72 79 20 6f 66 | 20 4f 72 61 63 6c 65 20 |brary of| Oracle |
|00000320| 66 75 6e 63 74 69 6f 6e | 73 2e 20 20 41 6e 79 20 |function|s.  Any |
|00000330| 74 72 75 74 68 0a 3a 20 | 3e 74 6f 20 74 68 69 73 |truth.: |>to this|
|00000340| 20 72 75 6d 6f 72 2c 20 | 61 6e 64 20 69 66 20 73 | rumor, |and if s|
|00000350| 6f 2c 20 77 68 65 72 65 | 20 63 61 6e 20 49 20 6f |o, where| can I o|
|00000360| 62 74 61 69 6e 20 61 20 | 63 6f 70 79 3f 20 20 54 |btain a |copy?  T|
|00000370| 68 61 6e 6b 73 2e 0a 3a | 20 3e 0a 3a 20 3e 53 74 |hanks..:| >.: >St|
|00000380| 65 77 61 72 74 20 50 65 | 6c 65 67 61 6e 20 3c 73 |ewart Pe|legan <s|
|00000390| 70 65 6c 65 67 61 6e 40 | 63 73 63 2e 63 6f 6d 3e |pelegan@|csc.com>|
|000003a0| 0a 3a 20 3e 43 6f 6d 70 | 75 74 65 72 20 53 63 69 |.: >Comp|uter Sci|
|000003b0| 65 6e 63 65 73 20 43 6f | 72 70 6f 72 61 74 69 6f |ences Co|rporatio|
|000003c0| 6e 0a 3a 20 3e 28 33 30 | 31 29 39 32 31 2d 33 32 |n.: >(30|1)921-32|
|000003d0| 30 36 0a 3a 20 3e 46 41 | 58 3a 28 33 30 31 29 38 |06.: >FA|X:(301)8|
|000003e0| 34 30 2d 38 39 33 34 0a | 3a 20 3e 0a 0a 3a 20 4e |40-8934.|: >..: N|
|000003f0| 6f 74 20 65 78 61 63 74 | 6c 79 20 61 20 52 45 58 |ot exact|ly a REX|
|00000400| 58 20 4c 69 62 20 6f 66 | 20 4f 72 61 63 6c 65 20 |X Lib of| Oracle |
|00000410| 46 75 6e 63 74 69 6f 6e | 73 2c 20 62 75 74 20 61 |Function|s, but a|
|00000420| 74 20 6c 65 61 73 74 20 | 69 6e 20 74 68 65 20 56 |t least |in the V|
|00000430| 4d 2f 43 4d 53 20 0a 3a | 20 77 6f 72 6c 64 2c 20 |M/CMS .:| world, |
|00000440| 50 52 4f 2a 52 45 58 58 | 20 69 73 20 61 76 61 69 |PRO*REXX| is avai|
|00000450| 6c 61 62 6c 65 20 66 72 | 6f 6d 20 4f 72 61 63 6c |lable fr|om Oracl|
|00000460| 65 2e 20 20 50 52 4f 2a | 52 45 58 58 20 61 6c 6c |e.  PRO*|REXX all|
|00000470| 6f 77 73 20 79 6f 75 20 | 74 6f 20 65 6d 62 65 64 |ows you |to embed|
|00000480| 0a 3a 20 53 51 4c 20 69 | 6e 20 72 65 78 78 20 65 |.: SQL i|n rexx e|
|00000490| 78 65 63 73 20 69 6e 20 | 61 20 66 61 73 68 69 6f |xecs in |a fashio|
|000004a0| 6e 20 76 65 72 79 20 73 | 69 6d 69 6c 61 72 20 74 |n very s|imilar t|
|000004b0| 6f 20 6f 74 68 65 72 20 | 33 47 4c 27 73 20 6c 69 |o other |3GL's li|
|000004c0| 6b 65 20 63 2e 20 20 49 | 27 76 65 20 75 73 65 64 |ke c.  I|'ve used|
|000004d0| 20 0a 3a 20 69 74 20 77 | 68 65 6e 20 49 20 77 61 | .: it w|hen I wa|
|000004e0| 6e 74 65 64 20 74 6f 20 | 64 6f 20 71 75 69 63 6b |nted to |do quick|
|000004f0| 20 61 6e 64 20 64 69 72 | 74 79 20 75 70 64 61 74 | and dir|ty updat|
|00000500| 69 6e 67 20 75 74 69 6c | 69 7a 69 6e 67 20 74 68 |ing util|izing th|
|00000510| 65 20 70 6f 77 65 72 20 | 6f 66 20 74 68 65 20 0a |e power |of the .|
|00000520| 3a 20 72 65 78 78 20 70 | 61 72 73 69 6e 67 20 66 |: rexx p|arsing f|
|00000530| 75 6e 63 74 69 6f 6e 73 | 2e 0a 0a 52 45 58 58 2f |unctions|...REXX/|
|00000540| 53 51 4c 20 69 73 20 77 | 68 61 74 20 79 6f 75 20 |SQL is w|hat you |
|00000550| 61 72 65 20 61 66 74 65 | 72 2e 20 41 6c 74 68 6f |are afte|r. Altho|
|00000560| 75 67 68 20 73 69 6d 69 | 6c 61 72 20 69 6e 20 63 |ugh simi|lar in c|
|00000570| 6f 6e 63 65 70 74 20 74 | 6f 20 50 52 4f 2a 52 45 |oncept t|o PRO*RE|
|00000580| 58 58 2c 0a 52 45 58 58 | 2f 53 51 4c 20 69 6d 70 |XX,.REXX|/SQL imp|
|00000590| 6c 65 6d 65 6e 74 65 73 | 20 61 6c 6c 20 63 61 6c |lementes| all cal|
|000005a0| 6c 73 20 74 6f 20 4f 72 | 61 63 6c 65 20 28 61 6e |ls to Or|acle (an|
|000005b0| 64 20 74 68 65 20 6f 74 | 68 65 72 20 73 75 70 70 |d the ot|her supp|
|000005c0| 6f 72 74 65 64 0a 64 61 | 74 61 62 61 73 65 73 29 |orted.da|tabases)|
|000005d0| 20 76 69 61 20 66 75 6e | 63 74 69 6f 6e 20 63 61 | via fun|ction ca|
|000005e0| 6c 6c 73 20 72 61 74 68 | 65 72 20 74 68 61 6e 20 |lls rath|er than |
|000005f0| 65 6d 62 65 64 65 64 20 | 53 51 4c 2e 20 65 67 0a |embeded |SQL. eg.|
|00000600| 0a 72 63 20 3d 20 73 71 | 6c 63 6f 6e 6e 65 63 74 |.rc = sq|lconnect|
|00000610| 28 27 73 63 6f 74 74 2f | 74 69 67 65 72 27 29 0a |('scott/|tiger').|
|00000620| 72 63 20 3d 20 73 71 6c | 63 6f 6d 6d 61 6e 64 28 |rc = sql|command(|
|00000630| 71 31 2c 27 73 65 6c 65 | 63 74 20 2a 20 66 72 6f |q1,'sele|ct * fro|
|00000640| 6d 20 65 6d 70 27 29 0a | 2e 2e 2e 0a 0a 54 68 65 |m emp').|.....The|
|00000650| 20 52 45 58 58 2f 53 51 | 4c 20 66 75 6e 63 74 69 | REXX/SQ|L functi|
|00000660| 6f 6e 73 20 61 72 65 20 | 76 65 72 79 20 73 69 6d |ons are |very sim|
|00000670| 69 6c 61 72 20 74 6f 20 | 74 68 65 20 58 2f 4f 70 |ilar to |the X/Op|
|00000680| 65 6e 20 43 61 6c 6c 20 | 4c 65 76 65 6c 0a 49 6e |en Call |Level.In|
|00000690| 74 65 72 66 61 63 65 20 | 53 70 65 63 69 66 69 63 |terface |Specific|
|000006a0| 61 74 69 6f 6e 20 66 6f | 72 20 43 2e 0a 0a 4d 79 |ation fo|r C...My|
|000006b0| 20 57 57 57 20 68 6f 6d | 65 20 70 61 67 65 20 62 | WWW hom|e page b|
|000006c0| 65 6c 6f 77 20 68 61 73 | 20 6d 6f 72 65 20 69 6e |elow has| more in|
|000006d0| 66 6f 72 6d 61 74 69 6f | 6e 20 69 6e 63 6c 75 64 |formatio|n includ|
|000006e0| 69 6e 67 20 74 68 65 20 | 52 45 58 58 2f 53 51 4c |ing the |REXX/SQL|
|000006f0| 0a 52 65 66 65 72 65 6e | 63 65 2f 55 73 65 72 20 |.Referen|ce/User |
|00000700| 6d 61 6e 75 61 6c 20 6f | 6e 6c 69 6e 65 2e 0a 0a |manual o|nline...|
|00000710| 43 68 65 65 72 73 2c 20 | 4d 61 72 6b 0a 2d 2d 2d |Cheers, |Mark.---|
|00000720| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00000730| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00000740| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00000750| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00000760| 2d 2d 2d 2d 2d 0a 20 4d | 61 72 6b 20 48 65 73 73 |-----. M|ark Hess|
|00000770| 6c 69 6e 67 20 20 20 20 | 20 20 20 20 20 20 20 20 |ling    |        |
|00000780| 20 20 20 20 20 45 6d 61 | 69 6c 3a 20 20 20 20 20 |     Ema|il:     |
|00000790| 20 20 20 20 20 20 20 20 | 4d 2e 48 65 73 73 6c 69 |        |M.Hessli|
|000007a0| 6e 67 40 71 75 74 2e 65 | 64 75 2e 61 75 0a 20 33 |ng@qut.e|du.au. 3|
|000007b0| 36 20 44 61 76 69 64 20 | 52 6f 61 64 20 20 20 20 |6 David |Road    |
|000007c0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 50 68 6f |        |     Pho|
|000007d0| 6e 65 3a 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |ne:     |        |
|000007e0| 20 20 20 20 20 20 20 2b | 36 31 37 20 33 38 34 39 |       +|617 3849|
|000007f0| 20 37 37 33 31 0a 20 48 | 6f 6c 6c 61 6e 64 20 50 | 7731. H|olland P|
|00000800| 61 72 6b 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |ark     |        |
|00000810| 20 20 20 20 20 68 74 74 | 70 3a 2f 2f 77 77 77 2e |     htt|p://www.|
|00000820| 67 75 2e 65 64 75 2e 61 | 75 2f 67 77 69 73 2f 74 |gu.edu.a|u/gwis/t|
|00000830| 68 65 2f 6d 61 72 6b 68 | 2e 68 74 6d 6c 0a 20 42 |he/markh|.html. B|
|00000840| 72 69 73 62 61 6e 65 20 | 20 20 20 20 20 20 20 20 |risbane |        |
|00000850| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 2a 2a 2a |        |     ***|
|00000860| 2a 20 4d 61 69 6e 74 61 | 69 6e 65 72 20 50 44 43 |* Mainta|iner PDC|
|00000870| 75 72 73 65 73 20 26 20 | 52 45 58 58 2f 53 51 4c |urses & |REXX/SQL|
|00000880| 20 2a 2a 2a 2a 0a 20 51 | 4c 44 20 34 31 32 31 20 | ****. Q|LD 4121 |
|00000890| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|000008a0| 20 20 20 20 20 2a 2a 2a | 2a 2a 2a 2a 2a 2a 2a 2a |     ***|********|
|000008b0| 2a 2a 20 41 75 74 68 6f | 72 20 6f 66 20 54 48 45 |** Autho|r of THE|
|000008c0| 20 2a 2a 2a 2a 2a 2a 2a | 2a 2a 2a 2a 2a 0a 20 41 | *******|*****. A|
|000008d0| 75 73 74 72 61 6c 69 61 | 20 20 20 20 20 20 20 20 |ustralia|        |
|000008e0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 2a 2a 2a |        |     ***|
|000008f0| 2a 2a 2a 2a 2a 2a 2a 2a | 2a 2a 20 4d 65 6d 62 65 |********|** Membe|
|00000900| 72 20 52 65 78 78 4c 41 | 20 2a 2a 2a 2a 2a 2a 2a |r RexxLA| *******|
|00000910| 2a 2a 2a 2a 2a 0a 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |*****.--|--------|
|00000920| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00000930| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00000940| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00000950| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 0a    |--------|------. |
+--------+-------------------------+-------------------------+--------+--------+